UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zoxYWm20EYign1mF6MHvlTvuVIwiuDqxRmW9fzSxg0='
WHERE
key_id = 'dd6bf999d7c2b03fb9ec9ab136b3dcf0a088db378fcf0231e100ac0dab7877c5'
AND (
token = '0zoxYWm20EYign1mF6MHvlTvuVIwiuDqxRmW9fzSxg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)