UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7saVDYCX+mnpm8tOYWMkRzhSphJDuA0gAHTVoKkc1QI='
WHERE
key_id = '0f3fe7e6c62fbe7c320ecd0887a6c9711bae95e6b166adf1f92155335cf58945'
AND (
token = '7saVDYCX+mnpm8tOYWMkRzhSphJDuA0gAHTVoKkc1QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)