UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wGzJmuzceFn0S9dEapeBa984zx2ADoTEl/5/AK3f5QA='
WHERE
key_id = 'f09f7d4817b74d68cf2c0ba0dbcc6261c22ca0567863dfc1fe33e1b4a9c97628'
AND (
token = 'wGzJmuzceFn0S9dEapeBa984zx2ADoTEl/5/AK3f5QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)