UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ApFsyeXZ51G+2m0ZQwN+jER8TgCMvCuk93f/MyV8co='
WHERE
key_id = 'b7c4666413e56631735aeda8843b35d2b6bb173188c1f9244e43041ba42587ac'
AND (
token = '2ApFsyeXZ51G+2m0ZQwN+jER8TgCMvCuk93f/MyV8co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)