UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vMlzSs578TCjRwe198yPFZuDw51ccB6Vlve1OCTEF+s='
WHERE
key_id = '97b6755c7dea0c1e81cf79a18eff3c3a3de66e5106009d842805236d6d9ae4ca'
AND (
token = 'vMlzSs578TCjRwe198yPFZuDw51ccB6Vlve1OCTEF+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)