UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9G6XDO8EkVsz0E9rSKeJyY20IsyhIEKV29pPlxaxRpU='
WHERE
key_id = 'cd2c5966663e7097c5cfb03b81f485b8e1c3afdeab7414d7dc972e5b68f9599f'
AND (
token = '9G6XDO8EkVsz0E9rSKeJyY20IsyhIEKV29pPlxaxRpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)