UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qdLwnQlgZ66dCC5zr4eWsZG3HqR5zrK1nPlKXVSY8AM='
WHERE
key_id = 'a2efbfcf2a694c94f7802879bceae09ffeafb7180df0acc5ea9b26515ad18dc4'
AND (
token = 'qdLwnQlgZ66dCC5zr4eWsZG3HqR5zrK1nPlKXVSY8AM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)