UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5vbN18sWC3WnLPqLQAq/lK8CBQmcraAEHj0v8Rv9aVs='
WHERE
key_id = '1fab11e514f55b83c25ac6b0321324503853073426172e53d3c7e6f6af123bf2'
AND (
token = '5vbN18sWC3WnLPqLQAq/lK8CBQmcraAEHj0v8Rv9aVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)