UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zp/JVWpN98YxeuFxQhDCPut4EysgF+3JZXURyG4lkrs='
WHERE
key_id = '71e62107754f6fe7048ecbd037c76b7e8927655ca667e1a6152da04745c3ec23'
AND (
token = 'zp/JVWpN98YxeuFxQhDCPut4EysgF+3JZXURyG4lkrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)