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