UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HydblIFf5QxOsH+2zSWEpEHh0fngRlPHG7eVfddMY1g='
WHERE
key_id = 'b05259cb7a8085dbbe0dd24f14cd9ac6cf0921e48de3bdf99105bf3e857f0469'
AND (
token = 'HydblIFf5QxOsH+2zSWEpEHh0fngRlPHG7eVfddMY1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)