UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u/fUo63063mQ5XWqXknux39HKfXUk2kmfOPBV6tPHQ8='
WHERE
key_id = 'bbd31b6f64ef5c490e4e63e93ceb6336ed0facc35c571fbc23dfd9f23abb6c31'
AND (
token = 'u/fUo63063mQ5XWqXknux39HKfXUk2kmfOPBV6tPHQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)