UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kb/emz1VXthueCwr7RN7ZuMGJ9Sj0+5YBM/kBTy0Mas='
WHERE
key_id = 'f6811e040d879720f4a1970e05c44874625c827a52b4ab0aabbb8d993a3002ac'
AND (
token = 'kb/emz1VXthueCwr7RN7ZuMGJ9Sj0+5YBM/kBTy0Mas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)