UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZ2FzIVRZQrf4iU9+LWE1YjoPGvqBBh2TBlKGVnwVfk='
WHERE
key_id = '1af61facd56f96b4b482a9e9a41e921de2a9392edb4a688d070ee648650484ec'
AND (
token = 'KZ2FzIVRZQrf4iU9+LWE1YjoPGvqBBh2TBlKGVnwVfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)