UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1d7/cV/X6lysQeAc4jVli4AXSmqCYBSU+RuNCPR3qqI='
WHERE
key_id = 'b787cfab7b64c90499ca3e42650b85a8e01e1d9f9cd47d86c8a56c43e0afd6cf'
AND (
token = '1d7/cV/X6lysQeAc4jVli4AXSmqCYBSU+RuNCPR3qqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)