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