UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GkfnNjToiLJnrc8mcbg4pjPHRtVYW7D3A3Bv8A85Ok8='
WHERE
key_id = '0342ba20f592c482584071c7d9bb8f4b01dfe1454049cc6982abc57c8570bea1'
AND (
token = 'GkfnNjToiLJnrc8mcbg4pjPHRtVYW7D3A3Bv8A85Ok8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)