UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wIGEJ7tgt504MgBGqSgweuDDbWtMiZUhDBCFEwASfZg='
WHERE
key_id = 'd399ca31e25ac729f28434813c9a722a84f95c6f61ae3353e6b0787f5cf2638f'
AND (
token = 'wIGEJ7tgt504MgBGqSgweuDDbWtMiZUhDBCFEwASfZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)