UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AkdtkLOqn2X36kpGV0u7AZRhFpJPjNVzG2eNYkGiDhI='
WHERE
key_id = '5d2d2f1a1fc40d032ff944ad499b515b1282f83d597036d1fec110f871d62735'
AND (
token = 'AkdtkLOqn2X36kpGV0u7AZRhFpJPjNVzG2eNYkGiDhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)