UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sbgVqpLNE0N4anTM2DdVujAFooTLNPEmqKhEPRkLKE='
WHERE
key_id = '419de3b61e5ff794341abf66d85d9087114775c9e1ba9ed225e35febe00cfc24'
AND (
token = '3sbgVqpLNE0N4anTM2DdVujAFooTLNPEmqKhEPRkLKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)