UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7bfaOn2WA8NSlT0qsY42k+r4TkooV3+CRLNDofgXHg='
WHERE
key_id = '66a1aac65d552e26000c3291dae72fc3122c0b19f96b22e49443763a21ecb220'
AND (
token = 'q7bfaOn2WA8NSlT0qsY42k+r4TkooV3+CRLNDofgXHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)