UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wJwkvFCiCrf1vaq1nET1ZSc2FUL7+3N3cUXMKlQjsE='
WHERE
key_id = 'd272a9a7973b16255ac1aadae936dd4ead97265f6c835f8b9cf106b12116dd67'
AND (
token = '0wJwkvFCiCrf1vaq1nET1ZSc2FUL7+3N3cUXMKlQjsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)