UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jd7yYtL7cXbQ67b1gZ3C/k58LF4mNJGZ0Y9MlEtAk1s='
WHERE
key_id = 'cfd71e21d27da528c82fe1fccc236b73a255484b8a8bbac55e5b70e9eaaffebd'
AND (
token = 'Jd7yYtL7cXbQ67b1gZ3C/k58LF4mNJGZ0Y9MlEtAk1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)