UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHz2A8KZdf8h5PEjs40A+gPTlUvx9KQK5mq244XBq+w='
WHERE
key_id = '0d63d3e8be7b01361131d0f855e04d178f451714f0efa01cb01689a88b747d12'
AND (
token = 'ZHz2A8KZdf8h5PEjs40A+gPTlUvx9KQK5mq244XBq+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)