UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wNZ38DlEG41ufhgcpdt3qIlaUDb1VO5vhabDFHvaDUM='
WHERE
key_id = 'caa69aabc0c00ea90bc56ca4aa99cc30453d38cbe7add9981ed5a6260ad96dcc'
AND (
token = 'wNZ38DlEG41ufhgcpdt3qIlaUDb1VO5vhabDFHvaDUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)