UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+2thIt3EDRdZuOWyUKKzdSwwUPslVTXeEXoBjGazCag='
WHERE
key_id = 'd8a07e767509683e48ad136769e18e26ccc27e67be9691a4c1d4a017d02ac42f'
AND (
token = '+2thIt3EDRdZuOWyUKKzdSwwUPslVTXeEXoBjGazCag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)