UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJf5KlYvnZi7sT9QjcwauRNV/1WCFEWe6AihymNhyFo='
WHERE
key_id = '6e4eae1d4560010def258819da8cfe8ded2968b0fbefda9e331061a66bc966bb'
AND (
token = 'VJf5KlYvnZi7sT9QjcwauRNV/1WCFEWe6AihymNhyFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)