UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFvrxYD5itfbAfbdZHsPEJq/3rmi9J9ygUx5zGhXieE='
WHERE
key_id = 'a9edaf893baa4d499eb7e6593aef48f428fb8bb58963397ddbdd3ddb94b6b20b'
AND (
token = 'HFvrxYD5itfbAfbdZHsPEJq/3rmi9J9ygUx5zGhXieE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)