UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9z3yUpr0g7wxRdm3PDW0d6azjNwYLILvBbgEYzxkKk='
WHERE
key_id = '948e0e802723fc6995268608850476e1a2701628a436d7e5e43863029c1c5a1b'
AND (
token = 'N9z3yUpr0g7wxRdm3PDW0d6azjNwYLILvBbgEYzxkKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)