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