UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8+qX/U60CW8eNg/S1W3J0TFBtw171/FByQFi0EyGIQ='
WHERE
key_id = '5231f063956a0094e7610fa4c0d3819c9b37707c7b2db93d8d3746a1b3ecb20d'
AND (
token = 'r8+qX/U60CW8eNg/S1W3J0TFBtw171/FByQFi0EyGIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)