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