UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNXTMKiL/eCnk28cMF8l0ebV0ajeVOwlJoK+/vSWTMA='
WHERE
key_id = 'afc787859e5a7360261046fe850db1ba917c4e6401073461f96c75c07ae5c6fd'
AND (
token = 'NNXTMKiL/eCnk28cMF8l0ebV0ajeVOwlJoK+/vSWTMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)